﻿using FluentMigrator;

namespace ProgressTracker.Data.Migrations
{
    [Migration(201403090300)]
    public class _0300_Make_Notes_Field_Nullable : Migration
    {
        public override void Up()
        {
            Alter.Table("Days").AlterColumn("Notes").AsString().Nullable();
        }

        public override void Down()
        {
            Execute.Sql("update Day set Notes = '' where Notes is null");
            Alter.Table("Day").AlterColumn("Notes").AsString().NotNullable();
        }
    }
}
